Working with Find queries
Using Find, you can create queries and search for records. When you query a database, Sage 100 Contractor locates all the records that match the criteria and displays the results in a Quick Report window. You can then select a record for display.
Queries are specific to the windows in which you create them. Suppose that in the Accounts Payable Invoices window you create a query titled Disputed Invoices, which searches for payable invoices assigned status 3-Dispute. You can only find the Disputed Invoices query in the Accounts Payable Invoices window. It will not appear elsewhere in Sage 100 Contractor.
After using Find to query a database, Sage 100 Contractor displays the results in a Quick Report window. You can select a record, and then click the Drill Down button to display the record. When you are finished examining the record, close the window in which it appeared.
- On the File menu, click Find.
- Click New.
- In the Name box, enter the name of the query.
- Using the Query Wizard, create the query.
Tip: After you create a query, Sage 100 Contractor automatically saves it.
- On the File menu, click Find.
- In the list, click the query you want.
- Click Run.
- On the File menu, click Find.
- In the list, click the query you want.
- Click Delete.